{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"NAME","type":"character","width":20},{"name":"TYPE","type":"character","width":10},{"name":"DEF","type":"character","width":12},{"name":"SYNTAX","type":"character","width":60},{"name":"RETURNS1","type":"character","width":60},{"name":"RETURNS2","type":"character","width":60},{"name":"PURPOSE","type":"character","width":60},{"name":"PURPOSE1","type":"character","width":60},{"name":"EXAMPLE1","type":"character","width":60},{"name":"EXAMPLE2","type":"character","width":60},{"name":"EXAMPLE3","type":"character","width":60},{"name":"EXAMPLE4","type":"character","width":60},{"name":"EXAMPLE5","type":"character","width":60},{"name":"LOCATION","type":"character","width":12},{"name":"DB","type":"character","width":6},{"name":"CLIP","type":"character","width":6},{"name":"AUTHOR","type":"character","width":20}],"n_rows":413,"rows_kept":413,"cut":false,"deleted_skipped":0,"read_ended":"whole","bounds":"16MiB/16384/4096/first_that_fit","version":"dbase_level_three","encoding_class":"enc_absent","reader":"statdb_count/9"}
["ADEL()","ARRAYS","Function","ADEL(<array>,<pos>)",null,null,"Shift array elements down one position from pos position",null,"FOR i = pos TO LEN(array)-1  && equivalent","array[i] = array[i +1]","NEXT",null,null,"DBU.LIB",null,"Yes","NANTUCKET"]
["ADIR()","ARRAYS","Function","ADIR(<skeleton>[,<array>])",null,null,"Fill an array with filenames from disk directory",null,"DECLARE textfiles[ADIR(\"*.TXT\")]  && declare array size","ADIR(\"*.TXT\", textfiles)          && fill array with names",null,null,null,"DBU.LIB",null,"Yes","NANTUCKET"]
["AFILL()","ARRAYS","Function","AFILL(<array>,<val>[,<start> [,<count>]])",null,null,"Fill many array elements with one value",null,"FOR i = start TO start + count - 1  && Equivalent","array[i] = val","NEXT",null,null,"DBU.LIB",null,null,"CLIP"]
["AINS()","ARRAYS","Function","AINS(<array>,<pos>)",null,null,"Shift array elements up one position below pos",null,"DO WHILE i > pos   && equivalent ..where i = LEN(array)","array[i] = array[i-1]","i = i - 1","ENDDO",null,"DBU.LIB",null,null,"NANTUCKET"]
["ARRREST()","ARRAYS","UDF","ARRREST(<filespec>,<array name>)","<expL> .T. if restored properly, otherwise .F.",null,"Restore a Clipper array from a disk file",null,null,null,null,null,null,"TR.LIB",null,null,"RETTIG"]
["ARRSAVE()","ARRAYS","UDF","ARRSAVE(<filespec>,<array name>)","<expL> .T. if written correctly to disk, otherwise .F.",null,"Save a Clipper array to a disk file",null,null,null,null,null,null,"TR.LIB",null,null,"RETTIG"]
["ARRSORT()","ARRAYS","UDF","ARRSORT(<source array>,<target array>)","<expL> true if successful, false if not",null,"Sort a numeric,date or logical array in ascending order",null,"* Sort array1 to array2","IF .NOT. ARRSORT(\"array1\",\"array2\")","? \"Error sorting array\"","ENDIF",null,"TR.LIB",null,null,"RETTIG"]
["ASCAN()","ARRAYS","UDF","ASCAN(<array>, <val> [,<start> [,<count>]])",null,null,"Search for specific value within an array",null,"FOR i = start TO start + count -1  && Equivalent","IIF array[i] = val,RETURN(1)","NEXT",null,null,"DBU.LIB",null,null,"NANTUCKET"]
["ATYPE()","ARRAYS","UDF","ATYPE( <array name>[[<element number>]])","<expC> uppercase letter indicating data type (same as the","TYPE() function but adds \"A\" for array type","Distinguish array names from memvar names, and determine","type of an array element.",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["CREACHAR","ARRAYS","UDF","CALL CREACHAR WITH <elements>,<size>,<expN3>","<expN3> -1 if memory allocation error occurs",null,"Allocate memory for a C character array",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["DECLARE","ARRAYS","Command","DECLARE <array name> [<expN>][,<array list>]",null,null,"Creates a one-dimentional array, elements can be mixed.",null,"DECLARE up_alpha[26]","FOR i = 1 TO 26","up_alpha[i] = CHR(64 +i)","NEXT",null,"CLIPPER",null,"Yes","NANTUCKET"]
["FREECHAR","ARRAYS","Procedure","CALL FREECHAR",null,null,"Release memory allocated by CREACHAR for C character array",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["PASSARR","ARRAYS","Procedure","CALL PASSARR WITH <element>,<position>",null,null,"Pass a Clipper numeric,date or logical array to C for faster","processing or writing to a disk file",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["PASSCHAR","ARRAYS","Procedure","CALL PASSCHAR WITH <element>",null,null,"Pass a Clipper character array to C for faster processing","or writing to a disk file",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["READARRC","ARRAYS","UDF","CALL READARRC WITH <filespec>,<elements>,<size>,<error>","<expN3>-1 if read error occurs",null,"Read a character array from a disk file into a C array",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["READARRN","ARRAYS","Procedure","CALL READARRN WITH <filespec>,<expN1>,<expN2>","<expN2> -1 if read error occurs",null,"Read a numeric,date, or logical array from a disk file into","a C array",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["RETARR","ARRAYS","Procedure","CALL RETARR WITH <variable>,<array position>",null,null,"Return an array from C to Clipper",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["RETCHAR","ARRAYS","Procedure","CALL RETCHAR WITH <memvar>",null,null,"Return an array from C to Clipper",null,null,null,null,null,null,null,null,null,"RETTIG"]
["SORTARRN","ARRAYS","Procedure","CALL SORTARRN WITH <array length>",null,null,"Sort a Clipper date/logical/numeric array in C",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["WRITARRC","ARRAYS","Procedure","CALL WRITARRC WITH <filespec>,<elements>,<size>,<error>","<expN3> -1 if write error occurs",null,"Write a C character array to a disk file",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["WRITARRN","ARRAYS","Procedure","CALL WRITARRN WITH <filespec>,<elements>,<error>","<expN2> -1 if write error occurs",null,"Write a C numeric, date, or logical array to a disk file",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["DEPDB()","BUSINESS","UDF","DEPDB( <value>,<rate>,<periods> )","<expN> total depreciation over <expN3> periods",null,"Computes depreciation of an item as a percentage of its","current value",null,null,null,null,null,"TR.LIB",null,"Ye","RETTIG"]
["DEPSL()","BUSINESS","UDF","DEPSL( <price>,<value>,<life>,<periods> )","<expN> total depreciation over <expN4> periods",null,"Compute depreciation of an item by straight-line method",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["DEPVALDB()","BUSINESS","UDF","DEPVALDB( <price>,<rate>,<periods> )","<expN> value of asset after specified time",null,"Compute the depreciated value of an asset using declining-","balance method",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["DEPVALSL()","BUSINESS","UDF","DEPVALSL(<price>,<value>,<life>,<time> )","<expN> value of an asset after specified time",null,"Compute depreciated value of an asset using straight-line","method",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["EFFYIELD()","BUSINESS","UDF","EFFYIELD( <rate>, <compounded> )","Effective yield (effective rate of interest)",null,"Computes the effective rate of interest of a loan",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["EOQ()","BUSINESS","UDF","EOQ( <on hand>,<demand>,<cost>,<price>,<overhand>)","<expN> economic order quantity",null,"Compute economic order quantity of an item",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["INCTIME()","BUSINESS","UDF","INCTIME( <increase>,<rate>,<compounded> )","<expN> number of years required for specified appreciation",null,"Determine number of years for an investment to increase by","a specified amount",null,null,null,null,null,null,null,null,"RETTIG"]
["TOMONEY()","BUSINESS","UDF","TOMONEY( <expN> )","<expC> of <expN> in words in the format","\"... DOLLAR(S) and <n> CENT(S)\"","Convert a numeric amount to words of currency",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["ALLTRIM()","CHARACTER","UDF","ALLTRIM(<expC>)","<expC> with leading and trailing blanks removed",null,"Remove blanks from both ends of a string",null,null,null,null,null,null,"TR.LIB","Yes",null,"RETTIG"]
["ASC()","CHARACTER","Function","ASC(<expC>)","Converts the first character of a string into ASCII code",null,null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["AT()","CHARACTER","Function","AT(<expC>,<expC>)","Returns a number that shows the starting position of a","character string within another character string",null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["ATLAST()","CHARACTER","UDF","ATLAST(<character>,<string>)","<expN> position of last occurrence of <character> in","<string>","Determine rightmost position of character in string",null,"ATLAST( \"a\",\"AAABBaCdda\")   && Returns 10","ATLAST( \"b\",\"AAABBaCdda\")   && Returns 0","ATLAST( \"A\",\"AAABBaCdda\")   && Returns 3",null,null,"TR.LIB",null,null,"RETTIG"]
["ATNEXT()","CHARACTER","UDF","ATNEXT(<character>,<string>,<occurrence>)","<expN> position of <occurrance> of <characters> in <string>",null,"Determines position of <n>th occurance of char in string",null,"ATNEXT( \"A\", \"AAABBaCdda\", 0)  && Returns 0","ATNEXT( \"A\", \"AAABBaCdda\", 1)  && Returns 1","ATNEXT( \"A\", \"AAABBaCdda\", 3)  && Returns 3","ATNEXT( \"a\", \"AAABBaCdda\", 1)  && Returns 6",null,"TR.LIB",null,null,"RETTIG"]
["CAPFIRST()","CHARACTER","UDF","CAPFIRST( <expC>)","<expC> with the first alpha character of each new word","uppercase and all other alpha characters lowercase","Capitalize the first letter of each word, lowercase the","rest",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["CENTER()","CHARACTER","UDF","CENTER( <string>, <width>)","<expC> of <string> with enough leading blanks added to","center in <width>","Center output without calculating its starting position",null,"* Column is zero, <width> is screen size","@ ROW(),0 SAY CENTER(\"Hello, world!\",80)",null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["CHR()","CHARACTER","Function","CHR(<expN>)","Return the ASCII representation of a number",null,null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["CHRCOUNT()","CHARACTER","UDF","CHRCOUNT( <character>,<string>)","<expN> number of times <character> occurs in <string>",null,"Determine how many times a specified character occurs in","a string",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["CHRFOUND()","CHARACTER","UDF","CHRFOUND( <string1>, <string2>)","<expL> true if each character in <string1> also occurs in","<string2> in any order, otherwise false","Determine whether <string2> contains ALL the characters that","occur in <string1> regardless of the order","CHRFOUND( \"cAb\", \"AAABBaCdda\" )  && Returns .F.","CHRFOUND( \"CaB\", \"AAABBaCdda\" )  && Returns .T.","CHRFOUND( \"b\", \"AAABBaCdda\" )    && Returns .F.","CHRFOUND( \"ddddd\", \"AAABBaCdda\") && Returns .T.",null,"TR.LIB",null,"Yes","RETTIG"]
["CHRSWAP()","CHARACTER","UDF","CHRSWAP( <string>,<char1> [,<char2>])","<expC> string with all occurances of <char1> replaced",null,"Replace one character with another throughout a string, or","remove a character completely from a string","CHRSWAP( \"AAABBaCdda\", \"A\")    && Returns \"BBaCdda\"","CHRSWAP( \"AAABBaCdda\",\"A\",\"Z\") && Returns \"ZZZBBaCdda\"","CHRSWAP( \"AAABBaCdda\",\"a\",\"z\") && Returns \"AAABBzddz\"",null,null,"TR.LIB",null,"Yes","RETTIG"]
["CTOD()","DATE","Function","CTOD(<expC>)","Converts a date that has been stored/entered as a","character string into a date string",null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["DECRYPT()","CHARACTER","UDF","DECRYPT( <expC>, <password> )","<expC> of <string> decoded according to <password>",null,"Unprotect data that was protected with ENCRYPT()",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["DTOC()","DATE","Function","DTOC(<expD>)","Converts a date variable into  a character variable",null,null,null,null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["ENCRYPT()","CHARACTER","UDF","ENCRYPT( <expC>, <password> )","<expC> of <string> coded according to <password>",null,"Protect data from easily being read",null,"REPLACE ALL Field WITH ENCRYPT( Field, \"My Password\" )","@...SAY DECRYPT( Field, \"My Password\" )",null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["EXPAND","CHARACTER","UDF","EXPAND( <string>[,<spaces>] )","<expC> string with <spaces> between each character",null,"Expand string with spaces for headers and titles",null,"EXPAND(\"Library\",2)","\"L  i  b  r  a  r  y\"",null,null,null,"TR.LIB",null,null,"RETTIG"]
["ISALPHA()","CHARACTER","Function","ISALPHA()","Returns a logical .T. if specified character expression","begins with a alpha character","Evalute 1st character of an expression for alpha",null,"? ISALPHA(\"ABC-123\")",".T.",null,"? ISALPHA(\"123-ABC\")",".F.",null,"Yes",null,"PLUS"]
["ISLOWER()","CHARACTER","Function","ISLOWER( <expC>)","Returns a logical .T. if the leftmost character of an","expression is a lowercase letter","Evaluate for lower case",null,"? ISLOWER(\"aBC-234\")",".T.",null,"? ISLOWER(\"Abc-234\")",".F.",null,"Yes",null,"PLUS"]
["ISUPPER()","CHARACTER","Function","ISUPPER( <expC>)","Returns a logical .T. if the leftmost character of string","is an uppercase, Otherwise, returns a logical .F.","Evaluate for upper case",null,"? ISUPPER(\"aBC-234\")",".F.","? ISUPPER(\"Abc-234\")",".T.",null,null,"Yes",null,"PLUS"]
["LEADCHAR()","CHARACTER","UDF","LEADCHAR( <string>,<char> )","<expC> with each leading blank space in <string> replaced","by <char>","Display a string with leading characters other than blanks",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["LEFT()","CHARACTER","Function","LEFT( <expC>,<expN>)","Returns the specified number of characters from the left","of the alphanumeric argument","Substring selection from the left side",null,"? \"Dear \"+LEFT(\"John J. Smith\",4)","Dear John",null,null,null,null,"Yes",null,"PLUS"]
["LEN()","CHARACTER","Function","LEN()","Returns the number of characters in the alphanumeric","argument","Determines the length of a character string",null,"? LEN(\"James Smith\")","11",null,null,null,null,"Yes","Yes","PLUS"]
["LJUST()","CHARACTER","UDF","LJUST( <expC> )","<expC> with leading blanks moved to the end",null,"Left justify the contents of the string within that string",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["LOWER()","CHARACTER","Function","LOWER( <expC>)",null,null,"Converts upper case characters to lower case",null,"? LOWER(\"THIS IS A NICE DAY\")","this is a nice day",null,null,null,null,"Yes",null,"PLUS"]
["LTRIM()","CHARACTER","Function","LTRIM( <expC>)",null,null,"Removes the leading blanks that result from the STR","function","? STR(3.145,10,2)","3.15","? LTRIM(STR(3.145,10,2))","3.15",null,null,"Yes",null,"PLUS"]
["REPLICATE()","SCREEN","Function","REPLICATE(<expC>,<expN>)","Permits repeating a character expression a specified","number of times",null,null,"@ 1,0 SAY REPLICATE(\"*\",20)",null,"********************",null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["RIGHT()","CHARACTER","Function","RIGHT()",null,null,"SUBSTRING SELECTION FROM RIGHT SIDE",null,null,null,null,null,null,null,null,null,"PLUS"]
["RJUST()","CHARACTER","UDF","RJUST( <expC>)","<expC> with trailing blanks moved to the beginning",null,"Right justify the contents of a string with a string",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["RTRIM()","CHARACTER","Function","RTRIM(<expC>)","Removes trailing blanks from a character expression just","like the TRIM() function",null,null,null,null,null,null,null,"CLIPPER.lIB",null,null,"NANTUCKET"]
["SPACE()","CHARACTER","Function","SPACE(<expN>)","Creates a character string consisting of a specified","number of blank",null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["STUFF()","CHARACTER","Function","STUFF( <expC1>,<start>,<chars>,<expC2> )",null,null,"Replaces any part of a character string, without the need to","reconstruct the entire string","? STUFF('abc',2,1,'xyz')  && Retruns 'axyzc'","? STUFF('abc',2,1,'' )    && Returns 'ac'","? STUFF('abc',2,0,'xyz')  && Returns 'axyzbc'",null,null,null,"Yes",null,"PLUS"]
["SUBSTR()","CHARACTER","Function","SUBSTR(<expC>,<start position>[,<number of chars>]","Extracts a specified part of a character string",null,null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["TRIM()","CHARACTER","Function","TRIM(<expC>)","TRIM removes trailing blanks from a character string",null,null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["UPPER()","CHARACTER","Function","UPPER(<expC>)","Converts lower case characters into upper case characters",null,null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["VAL()","CHARACTER","Function","VAL(<expC>)","Converts a string character into a numeric expression",null,null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["WRAP()","CHARACTER","UDF","WRAP( <expC>,<max len> )","<expN> position of last blank space before <max len>",null,"Break a long string for output within a specified line","length",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["ALIAS()","DATABASE","Function","ALIAS([expN])","Returns the alias of a SELECT area",null,null,null,"USE invoice","SELECT 2","USE client","? ALIAS(1),ALIAS()  && Returns \"invoice client\"",null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["APPEND","DATABASE","Command","APPEND [scope][<fieldlist>]FROM<file>[FOR/WHILE]<condition>",null,null,"Adds records from other files to database files",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["APPEND BLANK","DATABASE","Command","APPEND BLANK",null,null,"Adds blank records to the end of the database file",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["APPEND FROM","DATABASE","DATABASE","APPEND FROM",null,null,"ADDS RECORDS FROM OTHER FILES",null,"USE File2","APPEND FROM File1",null,null,null,null,"Yes","Yes","PLUS"]
["APPEND FROM","DATABASE","DATABASE","APPEND FROM",null,null,"SUPPORTS FIELD LIST AS OPTIONAL ARGUMENT",null,null,null,null,null,null,null,null,null,"CLIP"]
["BOF()","DATABASE","Function","BOF()","Returns a logical .T. if the record pointer is at the","beginning of the file",null,null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["BROWSE","DATABASE","Interactive","BROWSE",null,null,"Allows Edit,Delete, Add to a database","Displays 17 records per screen",null,null,null,null,null,null,"Yes",null,"PLUS"]
["CHANGE","DATABASE","Interactive","CHANGE FIELDS <field list>",null,null,"Edits specified data fields sequentially, with or","without a qualifier","USE Employee","CHANGE FIELDS Annual_pay   && or",null,"USE Employee","CHANGE FIELDS Area_code,Phone_no FOR Area_code=\"206\"",null,"Yes",null,"PLUS"]
["CLOSE","SYSTEM","Command","CLOSE [ALTERNATE/DATABASES/FORMAT/INDEXES/PROCEDURE]",null,null,"Closes the specified type of file",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["CONTINUE","MISC","Command","CONTINUE",null,null,"Positions pointer to next record meeting LOCATE conditions",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["COPY FILE","DATABASE","Command","COPY FILE <filename> TO <filename>",null,null,"Duplicates any kind of file",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["COUNT","DATABASE","Command","COUNT [<scope>] [FOR/WHILE <condition>] TO <memvar>",null,null,"Tallies number of records that meet a specific condition",null,"USE Employee","COUNT TO Nrecords","COUNT FOR Annual_pay>=\"50000\" .AND. Male TO Richmen",null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["CREATE FROM","DATABASE","Command","CREATE <new file> FROM <structure extended file>",null,null,"Create forms a new database file from CREATE command file",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["CREATE","DATABASE","Command","CREATE <.dbf file name>",null,null,"Creates an empty structure extended file with 4 field",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["CREATE QUERY","DATABASE","Command","CREATE QUERY <filename>",null,null,"Creates a new query file (.QRY)",null,"USE Employee","CREATE QUERY Findempl.qry",null,null,null,null,"Yes",null,"PLUS"]
["CREATE VIEW","DATABASE","Command","CREATE VIEW <filename>",null,null,"Creates a new view file (.VUE)",null,"USE Employee","CREATE VIEW sample.vue",null,null,null,null,"Yes",null,"PLUS"]
["DELETE","DATABASE","Command","DELETE [<scope>] [FOR/WHILE <condition>]",null,null,"Flags the designated records for deletion",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["DELETED()","DATABASE","Function","DELETED()","Returns a value of true or false whether a record has been","deleted",null,null,null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["DISPLAY","DATABASE","Command","DISPLAY [OFF] <field list> [FOR/WHILE <condition>]",null,null,"Displays records from the active database",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["DISPLAY STRUCTURE","DATABASE","Interactive","DISPLAY STRUCTURE",null,null,"DISPLAYS STRUCTURE OF A DATABASE FILE IN USE",null,null,null,null,null,null,null,"Yes","No","PLUS"]
["EDIT","DATABASE","Interactive","EDIT [<scope>][FIELDS <list>][FOR/WHILE <condition>]",null,null,"Alters data fields in a database",null,null,null,null,null,null,null,"Yes",null,"dBASE PLUS"]
["EOF()","DATABASE","Function","EOF()",null,null,"END-OF-FILE",null,null,null,null,null,null,null,"Yes","Yes","NANTUCKET/AT"]
["ERASE","DISK","Command","ERASE <filename>",null,null,"Delete the specified file from the directory",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["EXPORT","DATABASE","Interactive","EXPORT",null,null,"CREATES A PFS FILE FROM A DATABASE",null,null,null,null,null,null,null,null,null,"PLUS"]
["FCOUNT()","DATABASE","Function","FCOUNT()","Returns the number of fields in the current database",null,null,null,"FOR i TO FCOUNT()","? FIELDNAME[i]","NEXT",null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["FIELD()","DATABASE","Function","FIELD()",null,null,"NAMES OF FIELDS IN DATABASE FILES",null,null,null,null,null,null,null,null,null,"PLUS"]
["FIELDNAME()","DATABASE","DATABASE Fun","FIELDNAME(<expN>)","The name of any field within the currently active","database",null,null,"Newfield = FIELDNAME(7)","? Newfield",null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["FIND","MISC","Command","FIND <character string>",null,null,"Positions pointer to 1st record whose key matches string",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["FLDCOUNT()","DATABASE","UDF","FLDCOUNT()","<expN> integer number of fields in the currently selected","database file","Determine the number of fields in a database file",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["FOUND()","MISC","Function","FOUND()","Returns .T. if a previous SEEK, FIND, LOCATE, or","CONTINUE was successful",null,null,"SEEK memvar","IF .NOT. FOUND()","? \"Record not in file\"","ENDIF",null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["GETAREA()","DATABASE","UDF","GETAREA( <workarea>, <function> )","Result of <function> in <workarea>",null,"Obtain the result of a function from other than the","currently selected workarea",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["GO","DATABASE","Command","GO/GOTO BOTTOM/TOP/<expN>",null,null,"Positions pointer directly to specified record",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["HEADER()","DATABASE","UDF","HEADER()",null,null,"Determine size of a database file header",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["IMPORT","DATABASE","Command","IMPORT",null,null,"CREATES DATABASE AND FORMAT FILES FROM PFS FILES",null,null,null,null,null,null,null,null,null,"PLUS"]
["INDEX","DATABASE","INDEX Comman","INDEX ON <exp> TO <.ntx file name>",null,null,"Causes database to appear to be sorted with specified key",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["INDEXKEY()","DATABASE","Function","INDEXKEY(<expN>)","Return the KEY expression of an index where <expN> is the","placement in the index list",null,null,"USE Customers INDEX Name,Serial","SET ORDER TO 2","? INDEXKEY(1)       && Returns Name.ntx key expression","? INDEXKEY(0)       && Returns Serial.ntx key expression",null,"CLIPPER",null,null,"NANTUCKET"]
["JOIN","DATABASE","Command","JOIN WITH <alias> TO <new file> FOR/WHILE <condition>",null,null,"Combines specified records and fields from two databases",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["LABEL FORM","MISC","Command","LABEL FORM <.lbl file> [SAMPLE][<scope>][TO PRINT]",null,null,"Prints labels using the specified label form file",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["LASTREC()","DATABASE","Function","LASTREC()","Returns the number of records in the curently active","database file",null,null,null,"? \"RECORDS IN FILE = \",LASTREC()",null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["LIST","DATABASE","Command","LIST [OFF][scope]<field list> [FOR/WHILE <condition>]",null,null,"Lists the contents of a database file",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["LOCATE","DATABASE","Command","LOCATE [<scope>] [FOR/WHILE <condition>]",null,null,"Positions to a record that meets a specified condition",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["LUPDATE()","DATABASE","Function","LUPDATE()","The date of the last update of the currently selected","database file","Show when a database file was last updated",null,"? LUPDATE()","06/27/86",null,null,null,null,"Yes",null,"PLUS"]
["MODIFY QUERY","DATABASE","Interactive","MODIFY QUERY",null,null,"MODIFIES A QUERY FILE",null,null,null,null,null,null,null,null,null,"PLUS"]
["MODIFY STRUCTURE","DATABASE","Interactive","MODIFY STRUCTURE",null,null,"CREATES A BACKUP OF A DATABASE FILE OR MEMO FILE",null,null,null,null,null,null,null,null,null,"PLUS"]
["MODIFY VIEW","DATABASE","Interactive","MODIFY VIEW",null,null,"MODIFIES A VIEW FILE",null,null,null,null,null,null,null,null,null,"PLUS"]
["NDX()","DATABASE","Function","NDX()",null,null,"NAMES OF OPEN INDEX FILES",null,null,null,null,null,null,null,"Yes","No","PLUS"]
["NDXSIZE()","DATABASE","INDEX UDF","NDXSIZE( <key size>,<number of records> )","<expN> maximum number of bytes in target index file that","could result from INDEX on <key> TO <TARGET>","Determine potential max size of a dBASE 3 PLUS index file",null,null,null,null,null,null,"TR.LIB",null,null,"RETTIG"]
["NEXTAREA()","DATABASE","UDF","NEXTAREA()","Lowest available work area as <expN> integer",null,"Obtain the next available work area",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["NTXSIZE()","DATABASE","UDF","NTXSIZE( <key size>,<number of records> )","<expN> number of bytes in INDEX ON <key> expression",null,"Determine potential maximum size of a Clipper index file",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["PACK","DATABASE","Command","PACK",null,null,"Removes database records marked for deletion",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["RECALL","DATABASE","Command","RECALL [<scope>] [FOR/WHILE <condition>]",null,null,"Reinstates records marked for deletion",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["RECNO()","DATABASE","Function","RECNO()","Permits access to the current record number of the selected","file",null,null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["RECOUNT()","DATABASE","Function","RECOUNT()",null,null,"NO. OF RECORDS IN DATABASE",null,null,null,null,null,null,null,null,null,"PLUS"]
["RECSIZE()","DATABASE","Function","RECSIZE()",null,null,"SIZE OF RECORD",null,null,null,null,null,null,null,null,null,"PLUS"]
["REINDEX","DATABASE","Command","REINDEX",null,null,"Rebuilds existing active index files",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["RENAME","DISK","Command","RENAME <current file name> TO <new file name>",null,null,"Provides a new name to an existing file",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["REPLACE","DATABASE","DATABASE Com","REPLACE [<scope>]<field> WITH <exp>[FOR/WHILE <condition>]",null,null,"Changes contents of data fields to specified values",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SEEK","DATABASE","Command","SEEK <expression>",null,null,"Positions pointer to 1st record that matches expression",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SELECT","DATABASE","Command","SELECT <work area/alias>",null,null,"Select 0 selects first unused area",null,"USE accounts","SELECT 2","USE temp","SELECT accounts",null,"CLIPPER",null,null,"NANTUCKET"]
["SET CATALOG TO","DATABASE","Command","SET CATALOG TO [ <.cat filename>/?]",null,null,"CREATES A NEW CATALOG",null,null,null,null,null,null,null,"Yes",null,"PLUS"]
["SET INDEX TO","DATABASE","Command","SET INDEX TO <.ntx file list>",null,null,"Opens the specified index file",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET/AT"]
["SET ORDER","DATABASE","Command","SET ORDER TO <expN>",null,null,"Sets up any open index file as primary, without the need","to close and reopen the files",null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["SET UNIQUE","DATABASE","Command","SET UNIQUE on/OFF",null,null,"Causes first/ALL record(s) with identical keys to be indexed",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SKIP","DATABASE","CLIPPER Comm","SKIP <expN>",null,null,"Positions pointer forward or backward",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SKIP","DATABASE","CLIPPER Comm","SKIP <expN> [ALIAS <selection>]",null,null,"SKIP 0 Writes dbf buffer,ALIAS moves pointer unselected file",null,"SKIP ALIAS 4  is the same as","SELECT 4","SKIP","SELECT 1",null,"CLIPPER",null,null,"NANTUCKET"]
["SORT","DATABASE","DATABASE","SORT",null,null,"CREATES A SORTED VERSION OF THE ACTIVE DATABASE FILE",null,null,null,null,null,null,null,null,null,"PLUS"]
["SORT","DATABASE","DATABASE","SORT",null,null,"CREATES A COPY OF A DATABASE FILE TO BE USED",null,null,null,null,null,null,null,null,null,"PLUS"]
["STREET()","CHARACTER","UDF","STREET( <street address> )","<expC> street name from <street address>",null,"Order a database by street name",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["TOTAL TO","DATABASE","Command","TOTAL TO <filename> ON <key> [scope] [FIELDS<fieldlist>]",null,null,"Creates a summary database containg numeric fields",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["UPDATE","DATABASE","Command","UPDATE",null,null,"ALLOWS BATCH UPDATES OF A DATABASE",null,null,null,null,null,null,null,null,null,"PLUS"]
["USE","DATABASE","Command","USE",null,null,"Specifies database to be used until another USE",null,null,null,null,null,null,null,null,null,"PLUS"]
["ZAP","DATABASE","Command","ZAP",null,null,"Removes all records from the active database file",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["BOQTR()","DATE","UDF","BOQTR( <expD>)","<expD> first day of the calendar quarter in which the","parameter date falls","Determine the beginning of the current calendar quarter",null,"Return date      Dates between","01/01/yy         01/01 - 03/31","04/01/yy         04/01 - 06/30","07/01/yy         07/01 - 09/30","10/01/yy         10/01 - 12/31","TR.LIB",null,"Yes","RETTIG"]
["BOW()","DATE","UDF","BOW( <expD>)","<expD> Monday of the week in which the parameter date","falls","Computer the beginning of the current week",null,"* Compute beginning of current week","m_weekbeg = BOW( DATE())",null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["CDOW()","DATE","Function","CDOW(<expD>)","Returns the name of the day of the week from a date","variable",null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["CDTOS()","DATE","UDF","CDTOS( <expC date>, <format>)","<date string> of <expC date> in the format \"YYYYMMDD\"",null,"Convert a character type date to a date string where it can","be validated and converted to a date type","* All December 10, 1986 and return \"19861210\"","CDTOS( \"121086\", \"MMDDYY\" )","CDTOS( \"86/12/10\", \"YY/MM/DD\" )","CDTOS( \"10.12.1986\", \"DD.MM.YYYY\" )",null,"TR.LIB",null,"Yes","RETTIG"]
["CMONTH()","DATE","Function","CMONTH(<expD>)","Returns the name of the month from a date variable",null,null,null,"* If today is 06/01/87","? CMONTH(DATE())","June",null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["CMONTHN()","DATE","UDF","CMONTHN( <month>)","<expC> name of month, lowercase with initial capital","Null if <month> is less than 1 or greater than 12","Get the character name of the month from a numeric month","parameter","conception = DATE()","add_months = 9","due_month = ((MONTH(conception)-1 + add_month) %12) +1","? \"Your baby is due in the month of \" + CMONTHD(due_month)",null,"TR.LIB",null,"Yes","RETTIG"]
["DAY()","DATE","Function","DAY(<expD>)","Returns the numeric value of the day of the month from a","date variable",null,null,"? DAY(CHRISTMAS)","25",null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["DOW()","DATE","Function","DOW(<expD>)","Returns a number that represents the day of the week from","a date variable",null,null,"* If today is Saturday June 6th","? DOW(DATE())","6",null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["DTOS()","DATE","Function","DTOS(<expD>)","Returns a string in YYYYMMDD format.  This can be used to","index on a date + character expression",null,null,"xmas = CTOD(\"12/25/87\")","? DTOS(xmas)    &&Returns \"19871225\"",null,null,null,"CLIPPER",null,"Yes","NANTUCKET"]
["EOQTR()","DATE","UDF","EOQTR( expD> )","<expD> last day of the calendar quarter in which the","parameter date falls","Determine the end of the current calendar quarter",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["EOW()","DATE","UDF","EOW( <expD>)","<expD> Sunday of the week in which the parameter date falls",null,"Compute the end of the current week",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["INMONTHS()","DATE","UDF","INMONTHS( <start>,<end> )","<expN> number of months between two dates",null,"Determine the number of months between two dates",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["INWEEKS()","DATE","UDF","INWEEKS( <start>,<end> )","<expN> number of weeks between two dates",null,"Determine the number of weeks between two dates",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["INWKDAYS()","DATE","UDF","INWKDAYS( <start>,<end> )","<expN> number of non_weekend days between two dates",null,"Determine the number of non-weekend days between two dates",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["ISDSDATE()","DATE","UDF","ISDSDATE( <date string> )","<expL> true if <date string> is valid in format and contents","otherwise false","Determine if a date string is valid",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["ISLEAP()","DATE","UDF","ISLEAP( <expD>/<year> )","<expL> true if <date> or <year> are a leap year, otherwise","false","Determine if a date is in a leap year",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["ISWKEND()","DATE","UDF","ISWKEND( <expD> )","<expL> true if date is a Saturday or Sunday, otherwise","false","Determine if a date is on a weekend",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["LASTDAY()","DATE","UDF","LASTDAY( <month>,<year> )","<expN> last day of the month",null,"Determine date of the last day of the month",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["MAKEDATE()","DATE","UDF","MAKEDATE(<date string>[,<months>]","Valid <expD> of <date string>, even if <date string> is","invalid date, plus or minus <months>","Make an invalid date string valid and (+) or (-) months",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["MONTH()","DATE","Function","MONTH()",null,null,"MONTH OF YEAR",null,null,null,null,null,null,null,null,null,"PLUS"]
["NTOD()","DATE","UDF","NTOD( <year>,<month>,<day> )","<expD> date type of <year>,<month> and <day>",null,"Convert numeric date parameters to date type",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["QUARTER()","DATE","UDF","QUARTER( <expD>)","<expN> quarter of the year corresponding to <expD>",null,"QUARTER OF YEAR OF SPECIFIED DATE",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["STOD()","DATE","UDF","STOD( <date string> )","<expD> date type of <date string>",null,"Convert date string to date type",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["WEEKDAYS()","DATE","UDF","WEEKDAYS( <date>,<days> )","<expD> of <date> plus or minue <days> NOT counting weekends",null,"Add or subtract non-weekend days to or from dates",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["YEAR()","DATE","Function","YEAR(<expD>)","Returns the complete numeric value of the year from a","date variable",null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["DISPLAY HISTORY","DEBUG","Interactive","DISPLAY HISTORY",null,null,"Displays the commands stored in HISTORY",null,null,null,null,null,null,null,"Yes","No","PLUS"]
["INT3","DEBUG","Procedure","CALL INT3",null,null,"Inserts a breakpoint into a program for machine-language","debugging or analysis",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["LIST HISTORY","DEBUG","Interactive","LIST HISTORY [LAST,<expN>][TO PRINT]",null,null,"Lists commands that are stored in the HISTORY mode.  It","scrolls without pausing at each full-screen display",null,null,null,null,null,null,"Yes","No","PLUS"]
["MEMDUMP","DEBUG","Procedure","CALL MEMDUMP WITH <exp>",null,null,"Views memory byte-by-byte in hex and ASCII form",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["RESUME","PROGRAM","Interactive","RESUME",null,null,"Causes a SUSPENDed program to resume execution",null,null,null,null,null,null,null,null,null,"PLUS"]
["SET DOHISTORY","DEBUG","Interactive","SET DOHISTORY on/OFF",null,null,"Determines whether commands from command files are recorded","in HISTORY as they execute, default = OFF",null,null,null,null,null,null,"Yes",null,"AT"]
["SET HISTORY TO","DEBUG","Interactive","SET HISTORY TO <expN>",null,null,"Specifies the number of executed commands stored in HISTORY",null,null,null,null,null,null,null,"Yes",null,"AT"]
["CURDIR()","DISK","UDF","CURDIR( <drive letter>)","<expC> optional letter of drive to examine",null,"Get name of current disk directory",null,"m_drive = SPACE(1)","@ 12,10 SAY \"Enter drive letter: \";","GET m_drive VALID ISDRIVE( m_drive )","READ","directory = CURDIR( m_drive)","TR.LIB",null,"Yes","RETTIG"]
["CURDRIVE()","DISK","UDF","CURDRIVE()","<expC> current drive as uppercase letter",null,"Determine currently logged in drive",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["DIRMAKE()","DISK","UDF","DIRMAKE( <directory> )","<expL> true if directory exists, false if the directory","could not be created","Create a directory if it does not already exist.  Useful","in installation programs",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["DISKSPACE()","DISK","Function","DISKSPACE()","Returns an integer representing the number of bytes","available on the default disk drive",null,null,"? DISKSPACE()","309248",null,null,null,null,"Yes",null,"PLUS"]
["FILE()","DISK","Function","FILE(<file name>)","FILE verifies the existence of a specified file",null,null,null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["ISDRIVE()","DISK","UDF","ISDRIVE( <drive> )","<expL> true if drive exists and is working, otherwise false",null,"Determine if a specified disk drive exists and is ready",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["ISFIXED()","DISK","UDF","ISFIXED( <drive> )","<expC> drive letter, uppercase or lowercase",null,"Determine if a specified disk drive is a hard disk, useful","in backup and installation programs",null,null,null,null,null,null,null,null,"RETTIG"]
["DISPLAY STATUS","DEBUG","Interactive","DISPLAY STATUS",null,null,"DISPLAYS CURRENT INFORMATION ABOUT THE FILES IN USE",null,null,null,null,null,null,null,"Yes","No","PLUS"]
["SELECT()","DATABASE","Function","SELECT()",null,null,"Returns the numeric value of thw currently selected area",null,"IF SELECT() =1","@ 23,0 SAY \"Editing main file\"","ELSE","@ 23,0 SAY \"Editing customer file\"","ENDIF","CLIPPER.LIB",null,"Yes","NANTUCKET"]
["SET ALTERNATE TO","DISK","Command","SET ALTERNATE TO <file name>",null,null,"Creates a file for saving output",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SET ALTERNATE","DATABASE","Command","SET ALTERNATE on/OFF",null,null,"Sends/DOES NOT SEND output to a file",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SET BELL","SYSTEM","Command","SET BELL on/OFF",null,null,"Bell rings/DOES NOT RING during data entry operation",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SET CARRY","MISC","Command","SET CARRY on/OFF",null,null,"Writes/DOES NOT WRITE last record into an APPEND",null,null,null,null,null,null,null,null,null,"PLUS"]
["SET CATALOG","DATABASE","Command","SET CATALOG ON/off",null,null,"ADDS/does not add files to the open catalog",null,null,null,null,null,null,null,"Yes",null,"AT"]
["SET CENTURY","DATE","Command","SET CENTURY on/OFF",null,null,"Shows/DOES NOT SHOW the century in date displays",null,null,null,null,null,null,null,null,null,"PLUS"]
["SET COLOR","SCREEN","Command","SET COLOR ON/OFF",null,null,"Switches between color and monochrome monitors on systems","with both types.  Default = system monitor",null,null,null,null,null,null,"Yes",null,"AT"]
["SET COLOR TO","SCREEN","Command","SET COLOR TO [<standard>[,<enhanced>][,<border>][<background",null,null,"Sets screen displays attributes",null,null,null,null,null,null,null,"Yes",null,"AT"]
["SET CONFIRM","SYSTEM","Command","SET CONFIRM on/OFF",null,null,"Requires/DOES NOT REQUIRE the carriage return",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SET CONSOLE","SCREEN","Command","SET CONSOLE ON/off",null,null,"SENDS/suspends all output to the screen",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SET DATE","DATE","Command","SET DATE American/Ansi/British/Italian/French/German",null,null,"Determines the format for date expressions",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET/AT"]
["SET DEBUG","DEBUG","Interactive","SET DEBUG on/OFF",null,null,"Sends/DOES NOT SEND output of ECHO to the printer",null,null,null,null,null,null,null,"Yes",null,"PLUS"]
["SET DECIMALS TO","NUMERIC","Command","SET DECIMALS TO <expN>",null,null,"Determines the minimum number of decimals displayed",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SET DEFAULT TO","DISK","Command","SET DEFAULT TO <drive>",null,null,"Specifies the default drive for file operations",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SET DELETED","DATABASE","Command","SET DELETED on/OFF",null,null,"Does not display/DISPLAYS records marked for deletion",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SET DELIMITERS TO","SCREEN","Command","SET DELIMITERS TO [<character string>]/[DEFAULT]",null,null,"Specifies delimiters for fields and variable displays",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SET DELIMITERS","SCREEN","Command","SET DELIMITERS on/OFF",null,null,"Displays full-screen fields in normal video/REVERSE VIDEO",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SET DEVICE TO","SYSTEM","Command","SET DEVICE TO SCREEN/print",null,null,"Sends  @..SAY command output to the SCREEN/printer",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SET ECHO","SCREEN","Interactive","SET ECHO on/OFF",null,null,"Displays command lines from program on the screen and/or","the printer during execution, default = OFF",null,null,null,null,null,null,"Yes",null,"AT"]
["SET ESCAPE","PROGRAM","Command","SET ESCAPE ON/off",null,null,"The default is ON, where:",null,"ON  =  <Esc> from GET...READ ignores VALID and Alt-C","allows for program termination.",null,"OFF =  Will not allow an escape to terminate a READ.  In","addition, the Alt-C is ignored.","CLIPPER.LIB","No","Yes","NANTUCKET"]
["SET ESCAPE","PROGRAM","Command","SET ESCAPE ON/off",null,null,"With SET ESCAPE ON, the ESC key interupts the program","With SET ESCAPE OFF, the ESC is disabled","*** INTERRUPTED ***","Called from <filename.prg>","what now - Cancel, Ignore, Suspend?(C,I, or S)",null,null,null,"Yes","No","AT"]
["SET EXACT","DATABASE","Command","SET EXACT on/OFF",null,null,"Requires/DOES NOT REQUIRE exact matches in char comparison",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SET FIELDS TO","DATABASE","Command","SET FIELDS TO [<field list>/ALL]",null,null,"Defines a list of fields that may be accessed in one or","more files",null,null,null,null,null,null,"Yes","No","AT"]
["SET FIELDS","DATABASE","Command","SET FIELDS on/OFF",null,null,"If SET FIELDS is OFF all fields in database are available","If SET FIELDS is ON, only fields in SET FIELDS TO are seen",null,null,null,null,null,null,"Yes","No","AT"]
["SET FILTER TO","DATABASE","CLIPPER Comm","SET FILTER TO [<condition>]",null,null,"Filters out database records not satisfying the condition",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SET FIXED","NUMERIC","Command","SET FIXED on/OFF",null,null,"Fixes/DOES NOT FIX the number of decimals to be displayed",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SET FORMAT TO","SCREEN","Command","SET FORMAT TO <.fmt file name>",null,null,"Opens a format file for data entry",null,"CLIPPER does not clear the screen before executing format","files.  However commands are allowed in format files.  When","use .CLP files with a program that has SET FORMAT TO","statements, the .FMT files must have .PRG file extensions.",null,"CLIPPER.LIB","No","Yes","NANTUCKET"]
["SET FORMAT TO","SCREEN","Command","SET FORMAT TO [<filename>/?]",null,null,"Opens a format file for data entry",null,null,null,null,null,null,null,"Yes",null,"AT"]
["SET FUNCTION","SYSTEM","Command","SET FUNCTION <expN> TO <character string>",null,null,"Used to re-program function 2 through 40",null,null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["SET HEADING","SCREEN","Command","SET HEADING ON/off",null,null,"Field names DISPLAY/do not in LIST or DISPLAY",null,null,null,null,null,null,null,"Yes",null,"AT"]
["SET HELP","DEBUG","Command","SET HELP ON/off",null,null,"PROMPTS/does not prompt user for help when an error occurs",null,null,null,null,null,null,null,"Yes",null,"AT"]
["SET HISTORY","DEBUG","Interactive","SET HISTORY ON/off",null,null,"Turns command history feature on and off",null,null,null,null,null,null,null,"Yes",null,"AT"]
["SET INTENSITY","SCREEN","Command","SET INTENSITY ON/off",null,null,"SETS ON/sets off the reverse video in full-screen operations",null,null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["SET KEY","SYSTEM","Command","SET KEY <expN> TO [<proc>]",null,null,"Allows a procedure to be executed from any wait state",null,"A wait state is defined as any command that pauses program-","WAIT, READ, ACCEPT, INPUT, MENU TO",null,"Note that INKEY() is not a wait state",null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["SET MARGIN TO","PRINTER","Command","SET MARGIN TO <expN>",null,null,"Sets the left margin of a printer",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["SET MEMOWIDTH TO","MEMO","Command","SET MEMOWIDTH TO",null,null,"Adjusts the column width of a memo field output","Default width is 50",null,null,null,null,null,null,"Yes",null,"PLUS"]
["SET MENUS","SCREEN","Command","SET MENUS ON/off",null,null,"DISPLAYS/does not display a cursor key menu during full","screen commands",null,null,null,null,null,null,"Yes",null,"AT"]
["SET MESSAGE","SCREEN","Command","SET MESSAGE TO <expN>",null,null,"Allows a related message fot each PROMPT to be displayed,","message will appear on line <expN>",null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["SET ORDER TO","DATABASE","ENVIRON","SET ORDER TO <expN>",null,null,"Sets up any open index file as the controlling file, where","<n> is the number of the file in the index series","USE Employee INDEX Lastname.ndx,Payrank.ndx,Areacode.ndx","SET ORDER TO 3",null,null,null,null,"Yes",null,"PLUS"]
["SET PATH TO","DISK","Command","SET PATH TO [<path list>]",null,null,"Specifies path for file search",null,"SET PATH TO C:\\DBDATE\\SALES",null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["SET PRINT","PRINTER","Command","SET PRINT on/OFF",null,null,"Sends/DOES NOT SEND output to a printer",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["SET PRINTER","NETWORK","Command","SET PRINTER TO <destination>",null,null,"Sets print output to LPT1,LPT2,COM1,COM2,file",null,"SET PRINTER TO LPT1","SET PRINTER TO Accounts.prn",null,null,null,"CLIPPER",null,"Yes","NANTUCKET"]
["SET PROCEDURE TO","PROGRAM","Command","SET PROCEDURE TO <procedure file name>",null,null,"Opens a named procedure file during compilation",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["SET RELATION TO","DATABASE","Command","SET RELATION TO <key exp> INTO <alias>",null,null,"Links two databases according to a key expression",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["SET SAFETY","DATABASE","Command","SET SAFETY ON/off",null,null,"PROMPTS/does not when a file is about to be overwritten",null,null,null,null,null,null,null,"Yes",null,"AT"]
["SET SCOREBOARD","SCREEN","Command","SET SCOREBOARD ON/off",null,null,"dBASE III/Clipper messages APPEAR/do not on the status","line",null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET/AT"]
["SET STEP","DEBUG","Interactive","SET STEP on/OFF",null,null,"Halts/DOES NOT HALT execution after each command processed",null,null,null,null,null,null,null,"Yes",null,"AT"]
["SET TALK","DEBUG","Interactive","SET TALK ON/off",null,null,"SENDS/does not send the results of commands to the screen",null,null,null,null,null,null,null,"Yes","No","AT"]
["SET TITLE","DATABASE","Command","SET TITLE ON/off",null,null,"PROMPTS/does not prompt for a catalog file title",null,null,null,null,null,null,null,"Yes","No","AT"]
["SET TYPEHEAD","SYSTEM","Command","SET TYPEHEAD TO <expN>",null,null,"Specifies the size of the type-ahead buffer",null,null,null,null,null,null,null,"Yes",null,"AT"]
["SET VIEW TO","DATABASE","Command","SET VIEW TO <.vue filename>",null,null,"Opens a view (.vue) file",null,null,null,null,null,null,null,"Yes",null,"AT"]
["LINES()","MEMO","UDF","LINES( <expC>, <line length> )","<expN> number of lines required to display <expC> within","<line length> columns","Determine number of lines in output at a specified line","length",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["TABSTRIP()","MEMO","UDF","TABSTRIP( <expC> [,<spaces per tab>] )","<expC> with tab characters replaced by spaces",null,"Eliminate tab characters from text",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["WPSTRIP()","MEMO","UDF","WPSTRIP( <expC> [,<spaces per tab>])","<expC> with tab, line-feed, and carriage-return characters","replaced by spaces","Eliminate word-processing characters from text",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["ACCEPT","SCREEN","Command","ACCEPT [<prompt>] TO <memvar>",null,null,"Stores a character string in a memory variable",null,"ACCEPT \"Enter your last name....\" TO LASTNAME   && or","ACCEPT TO LASTNAME",null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET/AT"]
["AVERAGE","NUMERIC","Command","AVERAGE <fieldlist> TO <memvarlist> [FOR/WHILE <condition>]",null,null,"Computes the arithmetic mean of multiple expressions",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["CLEAR ALL","SYSTEM","Command","CLEAR ALL",null,null,"Closes all database, index, format files & erases memvars",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["CLEAR MEMORY","MISC","Command","CLEAR MEMORY",null,null,"Erases current memory variables",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["DISPLAY MEMORY","DEBUG","Interactive","DISPLAY MEMORY",null,null,"DISPLAYS CURRENT MEMORY VARIABLES",null,null,null,null,null,null,null,"Yes","No","PLUS"]
["READ","DATABASE","Command","READ",null,null,"Permits data entry to a GET field or variable",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["RELEASE","SYSTEM","Command","RELEASE [<memvar>] [ALL [LIKE/EXCEPT <skeleton>]]",null,null,"Erase current memory variables",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["RESTORE FROM","DISK","Command","RESTORE FROM <.mem file name> [ADDITIVE]",null,null,"Retrieves sets of saved memory variables",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SAVE TO","DISK","MEMVAR Comma","SAVE TO <.mem filename> [ALL LIKE/EXCEPT <skeleton>]",null,null,"Copies current memory variables to a memory file",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["STORE","PROGRAM","Command","STORE",null,null,"STORES EXPRESSIONS INTO MEMORY VARIABLES",null,null,null,null,null,null,null,null,null,"PLUS"]
["WAIT","MISC","Command","WAIT",null,null,"ACCEPTS A SINGLE CHARACTER INTO A MEMORY VARIABLE",null,null,null,null,null,null,null,null,null,"PLUS"]
["ASSIST","MISC","Interactive","ASSIST",null,null,"MENU-DRIVEN",null,null,null,null,null,null,null,"Yes",null,"PLUS"]
["BLANK()","MISC","UDF","BLANK( <exp>)","Empty value of <exp>",null,"Obtain an empty value of any data type expression",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["CREATE LABEL","MISC","Interactive","CREATE LABEL <filename>",null,null,"Displays a design form to set up a label file (.LBL)",null,"CREATE LABEL Maillist",null,null,null,null,null,"Yes",null,"PLUS"]
["CREATE REPORT","MISC","Interactive","CREATE REPORT <filename>",null,null,"Displays a design form to set up a report form file (.FRM)",null,"CREATE REPORT Weekly",null,null,null,null,null,"Yes",null,"PLUS"]
["CREATE SCREEN","SCREEN","Interactive","CREATE SCREEN <filename>",null,null,"Creates a new screen file (.SCR)",null,"USE Employee","CREATE SCREEN Showempl.scr",null,null,null,null,"Yes",null,"PLUS"]
["FKLABEL()","MISC","Function","FKLABEL( <expN> )","<expC> contains the name of the function key whose number","corresponds to the numeric expression","Idenifies how the function keys are programmed",null,null,null,null,null,null,null,"Yes","No","AT"]
["FKMAX()","MISC","Function","FKMAX()","<expN> represents the number of programmable function key","on the terminal","Allows programmers to set the function keys to suit the","terminal in use",null,null,null,null,null,null,"Yes",null,"AT"]
["HARDCR()","MEMO","UDF","HARDCR(<expC>)","Returns the char expression with all soft carriage returns","CHR(141), replaced with carriage returns CHR(13)",null,null,"? HARDCR(notes)",null,null,null,null,"MEMO.LIB",null,"Yes","NANTUCKET"]
["LABEL","MISC","Command","LABEL",null,null,"DISPLAYS DATA IN THE FORM OF LABELS",null,null,null,null,null,null,null,"Yes",null,"PLUS"]
["MODIFY COMMAND","PROGRAM","Interactive","MODIFY COMMAND",null,null,"CREATES A COMMAND, FORMAT OR PROCEDURE FILE",null,null,null,null,null,null,null,"Yes","No","PLUS"]
["MODIFY LABEL","DATABASE","Interactive","MODIFY LABEL",null,null,"EDITS A LABEL FORM FILE",null,null,null,null,null,null,null,null,null,"PLUS"]
["MODIFY REPORT","DATABASE","Interactive","MODIFY REPORT",null,null,"MODIFIES A REPORT FORM FILE",null,null,null,null,null,null,null,null,null,"PLUS"]
["MODIFY SCREEN","SCREEN","Interactive","MODIFY SCREEN",null,null,"MODIFIES A SCREEN FILE",null,null,null,null,null,null,null,null,null,"PLUS"]
["PASSWORD()","CHARACTER","UDF","PASSWORD( <expC> )","<expN> in the range from eight to ten characters",null,"Store a password so that it cannot be read",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["REPORT FORM","PRINTER","Command","REPORT FORM <.frm filename> [<scope>][FOR/WHILE <condition>]",null,null,"Displays a tabular report of data",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["STATUS()","SYSTEM","UDF","STATUS( <SET parameter> )","<expC> or <expN> depending of SET parameter passed",null,"Retrieve the current value of the specified SET parameter",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["VERSION()","SYSTEM","MISC","VERSION()",null,null,"DBASE III PLUS VERSION NUMBER",null,null,null,null,null,null,null,null,null,"PLUS"]
["ABS()","NUMERIC","Function","ABS(<expN>)","Returns the absolute value of an numeric expression",null,"Provides an absolute value function",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["AVERAGE","NUMERIC","Function","AVERAGE",null,null,"COMPUTES AND DISPLAYS THE ARITHMETIC MEAN",null,null,null,null,null,null,null,null,null,"PLUS"]
["BASE()","NUMERIC","UDF","BASE(<base>,<decimal number>)","<expC> value of <decimal number> in math format of <base>",null,"Convert a decimal number (base 10) to another number base",null,null,null,null,null,null,"TR.LIB",null,null,"RETTIG"]
["BASE10()","NUMERIC","UDF","BASE10(<base>,<base number>)","<expN> decimal number (base 10) of <base number>",null,"Convert a different base value to decimal number (base 10)",null,null,null,null,null,null,"TR.LIB",null,null,"RETTIG"]
["BIN()","NUMERIC","UDF","BIN(<expN>)","<expC> binary value of <expN>",null,"Convert a decimal number to binary (base 2)",null,null,null,null,null,null,"TR.LIB",null,null,"RETTIG"]
["CEILING()","NUMERIC","UDF","CEILING( <expN>)","Integer just above <expN>",null,"Obtain an integer grater than <expN>",null,"CEILING( 2.1 )  && Returns 3","CEILING(  .3 )  && Returns 1","CEILING(-0.3 )  && Returns 0","CEILING(-2.9 )  && Returns -2",null,"TR.LIB",null,"Yes","RETTIG"]
["DEC()","NUMERIC","UDF","DEC( <hex string>)","<expN> decimal value of <expC> hex value, or zero if there","is an invalid character in <expC>","Convert a hexidecimal number (base 16) to a decimal","number (base 10)",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["EXP()","NUMERIC","Function","EXP()","The exponential value of the numeric argument",null,"Permits use of exponential functions",null,"? EXP(1.00000000)","2.71828183",null,null,null,null,"Yes",null,"PLUS"]
["EXPONENT","NUMERIC","UDF","EXPONENT( <expN> )","Power of 2 used to represent <expN>",null,"Determine memory representation of <expN>",null,"? EXPONENT( 100 )","6",null,null,null,"TR.LIB",null,null,"RETTIG"]
["FACT","NUMERIC","UDF","FACT( <expN> )","Product of all numbers between <expN> and 1",null,"Determine factorial of number",null,"m_number = 13","? FACT(m_number)",null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["FLR()","NUMERIC","UDF","FLR( <expN> )","Integer just below <expN>",null,"Obtain an integer less than <expN>",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["HEX()","NUMERIC","UDF","HEX( <expN> )","<expC> hexadecimal value of <expN>",null,"Convert a decimal number to hexadecimal (base 16)",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["INFINITY()","NUMERIC","UDF","INFINITY()","The bit pattern used by the 8087/80287 to represent","infinity (7F F0 00 00 00 00 00 00)","Provide an error return value for mathematical functions",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["INT()","NUMERIC","Function","INT(<expN>)","Converts any numeric expression into an integer",null,null,null,null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["LOG()","NUMERIC","Function","LOG( <expN> )","LOG returns the natural logarithm of a given number",null,"LOGARITHM",null,null,null,null,null,null,null,"Yes",null,"PLUS"]
["LOGNBASX()","NUMERIC","UDF","LOGNBASX( <number>,<base> )","the logarithm of the <expN> to the base <expN2>",null,"Give access to logarithms other than the natural logarithm",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["LOGTEN()","NUMERIC","UDF","LOGTEN( <expN> )","Logarithm of <expN> to the base 10",null,"Provide access to logarithms in the decimal system",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["MANTISSA()","NUMERIC","UDF","MANTISSA( <expN> )","Number between 1 and 1.9999999... which is multiplied by","the power of 2 necessary to product <expN>","Determine memory representation of <expN>",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["MAX()","NUMERIC","Function","MAX( <expN1>,<expN2>)","The higher value of two numerical expressions",null,"Locates the greater of two values",null,null,null,null,null,null,null,"Yes",null,"PLUS"]
["MIN()","NUMERIC","Function","MIN(<expN>/<expD>,<expN>/<expD>)","Returns the lesser value of two numeric or date expressions",null,null,null,null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["MOD()","NUMERIC","Function","MOD( <expN1>,<expN2>)","a number representing the remainder of <expN1> divided","by <expN2>","Provides modulus math operations",null,null,null,null,null,null,null,"Yes",null,"PLUS"]
["POWER()","NUMERIC","UDF","POWER( <number>,<power> )","<expN1> number being raised to <power>",null,"Raise a number to a power",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["ROOT()","NUMERIC","UDF","ROOT( <number>,<root> )","<expN> which is the <expN2> root of <expN1>",null,"Compute cube roots, fifth roots, etc",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["ROUND()","NUMERIC","Function","ROUND(<expN>,<decimals>)","Returns the rounded number to a specified number of","decimal places",null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SQRT()","NUMERIC","Function","SQRT(<expN>)","Returns the square root of a given positive number",null,null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["STR()","NUMERIC","Function","STR(<expN>[,<length>[,<decimals>]])","Converts a numeric expression into a character string",null,null,null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET/AT"]
["SUM","DATABASE","Command","SUM <fieldlist> TO <memvar> [FOR/WHILE <condition>]",null,null,"Totals fields with an active database file",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["EJECT","PRINTER","Command","EJECT","a form feed (ASCII 12) to the printer",null,"Ejects a page on the printer",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET/AT"]
["ISPRINTER()","PRINTER","UDF","ISPRINTER()","<expL> true if parallel printer is on-line and ready,","otherwise false","Determine if printer is ready to accept to accept output",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["LPTSWAP","PRINTER","UDF","CALL LPTSWAP",null,null,"Switches output between two printers (Assumes LPT1 & LPT2)",null,null,null,null,null,null,"TR.LIB",null,null,"RETTIG"]
["PRNSTATUS()","PRINTER","UDF","PRNSTATUS()","<expN> parallel printer status code",null,"Determine printer status",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["PRTSC","PRINTER","Procedure","CALL PRTSC",null,null,"Send current screen image to print",null,null,null,null,null,null,"TR.LIB",null,null,"RETTIG"]
["SETPRC()","PRINTER","CLIPPER Func","SETPRC(<expN>,<expN>)","SETS the internal PROW() and PCOL() values to specified","values",null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["TOF()","PRINTER","UDF","TOF()","<expL> true if printer is at top-of-form, otherwise false",null,"Detect if printhead is positioned at top-of-form",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["&","MISC","MACRO","&<character variable>",null,null,"Use anywhere in DO WHILE statement, nesting, recursion",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["?","SCREEN","Command","? <exp list>",null,null,"Displays an expression list on the next line of the CRT",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["@...BOX","SCREEN","Command","@ <top,left,bottom,right> BOX <string>",null,null,"Draw and fill box with any CHR() to frame menus,draw boxes",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["@...PROMPT","SCREEN","Command","@ <row,col> PROMPT <expC> [MESSAGE <expC>]",null,null,"Places menu selections on screen at the row,col location",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["@...SAY","SCREEN","Command","@ <row,col> [SAY <exp> [PICTURE <clause]] VALID <exp>]",null,null,"Displays user-formatted data on the screen or printer",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["@...TO","SCREEN","Command","@...TO",null,null,"DRAWS A BOX",null,null,null,null,null,null,null,null,null,"PLUS"]
["@..SAY..GET","SCREEN","Command","@ <rol,col> [SAY <expC> [PICTURE <clause>]] [GET <exp>]","Supports- [RANGE <exp,exp>]","Supports- [VALID <exp>]] [CLEAR]","Displays/inputs data, prompts for input util expression .T.",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["CALL","MISC","Program","CALL  <process> WITH <exp> [WITH WORD(<expN>)]",null,null,"CALL SEPARATELY COMPILED OR ASSEMBLED ROUTINES [WITH WORD()]",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["CANCEL","MISC","Command","CANCEL",null,null,"Aborts program execution and returns to DOS control",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["DO","PROGRAM","Command","DO",null,null,"CAUSES A PROGRAM OR PROCEDURE TO BE EXECUTED",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET/AT"]
["DO CASE","PROGRAM","Command","DO CASE...CASE...[OTHERWISE]...ENDCASE",null,null,"Permits execution of several possible paths (CASES)",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["DO WHILE","PROGRAM","Command","DO WHILE...ENDDO",null,null,"Permits structured loops in programs",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["EMPTY()","DATABASE","Function","EMPTY(<exp>)","Function evaluates TRUE if char is a null,num is 0, logical","is .F., and if a date is blank",null,null,"acct_no = SPACE(6)","@ 1,0 SAY \"Enter account\" GET acct_no","IF EMPTY(acct_no)","RETURN",null,"CLIPPER",null,"Yes","NANTUCKET"]
["ERROR()",null,"PROGRAMMG","ERROR()",null,null,"NUMBER FOR ON ERROR CONDITION",null,null,null,null,null,null,null,null,null,"PLUS"]
["EXIT","MISC","Command","EXIT",null,null,"Escapes a DO loop without terminating the program",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["EXTERNAL","MISC","Command","EXTERNAL",null,null,"DECLARE A SYMBOL FOR THE LINKER",null,null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["FOR NEXT","MISC","Command","FOR <memvar> = <expN> TO <expN> [STEP <expN>]...NEXT",null,null,"Loops in optional increments or decrements",null,null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["FUNCTION","MISC","Command","FUNCTION <name>...RETURN <value>",null,null,"Declares user-defined functions",null,null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["IF","PROGRAM","Command","IF...[ELSE]...ENDIF",null,null,"Allows conditional execution of commands in a program",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["IF()","PROGRAM","Function","IF(<exp1>,<exp2>,<exp3>)",null,null,"Conditional processing of expressions. IIF() also supported",null,"* To add \"am\" or \"pm\" to Time","? TIME() + IF(TIME() < \"12\",\"am\",\"pm\")",null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["IIF()","PROGRAM","Function","IIF(<expL>,<exp1>,<exp2>)","Provides a means of creating a conditional expression with","out using the IF...ENDIF command structure",null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["INKEY()","CHARACTER","Function","INKEY(<expN>)","Returns the ASCII code for a key pressed, INKEY(0) halts","til a key is pressed, INKEY(n) waits n sec or til keypress",null,null,"? \"Copyright 1987 EMULSIFIED SOFTWARE\"","? INKEY(0)          && Halt execution","CLEAR               && til key press then clear screen",null,null,"CLIPPER","Yes","Yes","NANTUCKET"]
["KEYBOARD","PROGRAM","Command","KEYBOARD <expC>",null,null,"Stuffs keyboard buffer with given string then flushes buffer",null,"* To return to main menu from three levels deep",null,"KEYBOARD \"Q\"+CHR(13)+\"Q\"+CHR(13)+\"Q\"+CHR(13)",null,null,"CLIPPER",null,"Yes","NANTUCKET"]
["LASTKEY()","MISC","Function","LASTKEY()","Returns the ASCII code for the last key pressed, including","control keys",null,null,"READ","last_key = LASTKEY()","IF last_key <> 27",null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["LOOP","PROGRAM","Command","LOOP",null,null,"LOOP returns control to the beginning of a DO WHILE...ENDDO","program structure",null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["MEMOEDIT()","MEMO","UDF","MEMOEDIT(<expC>,[<expN>,<expN>,<expN>,<expN>][,<expL>])","Edit memos, <expC>=memo,<expN>=4 coordinates of window,","<expL>=an update flag",null,null,"* edit current memo","REPLACE memo_field WITH MEMOEDIT(memo_field,5,10,20,69,.T.)","* display current memo","REPLACE memo_field WITH MEMOEDIT(memo_field,5,10,20,69,.F.)",null,"MEMO",null,"Yes","NANTUCKET"]
["MEMOREAD()","MEMO","UDF","MEMOREAD( <filename> )","Returns the contents of a text file read from disk",null,"Reads the contents of a text file into a memofield",null,"*  Notes is a memofield","REPLACE Notes WITH MEMOREAD(\"Temp.txt\")",null,null,null,"MEMO.LIB",null,"Yes","NANTUCKET"]
["MEMOTRAN()","MEMO","UDF","MEMOTRAN( <expC>[,hard-fix][soft-fix])","Returns <expC> with carriage return/line feed replaced","CHR(13)+CHR(10)=[hard-fix], CHR(141)+CHR(10)=[soft-fix]","To strip all the formatting characters from a memofield",null,"REPLACE Notes WITH MEMOTRAN(Notes,\"  \",\"  \")",null,null,null,null,"MEMO.LIB",null,"Yes","NANTUCKET"]
["MEMOWRIT()","MEMO","UDF","MEMOWRIT( <filename>,<expC> )","Returns a logical True .T. if successful",null,"Writes a character string to the specified disk file",null,"status = MEMOWRIT(\"Temp.txt\",Notes)","IF status","RUN Editor Temp.txt","ENDIF",null,"MEMO.LIB",null,"Yes","NANTUCKET"]
["MESSAGE()","MISC","Function","MESSAGE()","The error message character string",null,"On error message string",null,null,null,null,null,null,null,"Yes",null,"PLUS"]
["PARAMETERS","PROGRAM","Command","PARAMETERS <memvar list>",null,null,"Specifies optional values that can be passed to a procedure",null,null,null,null,null,null,"CLIPPER",null,null,"NANTUCKET"]
["PCOL()","PRINTER","Function","PCOL()",null,null,"PRINTER COLUMN POSITION",null,null,null,null,null,null,null,null,null,"PLUS"]
["PCOUNT()","PROGRAM","Function","PCOUNT()","Returns the number of parameters that have been passed","from the command line or another procedure","Count parameters passed to a procedure",null,"PARAMETER file","IF PCOUNT() =0","ACCEPT \"File to use:\" TO file","ENDIF","USE &file","CLIPPER.LIB",null,"Yes","NANTUCKET"]
["PRIVATE","PROGRAM","Command","PRIVATE <memory variable list>",null,null,"Hides memory variables from higher level command files",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["PROCEDURE","PROGRAM","Command","PROCEDURE <procedure name>",null,null,"Marks the beginning of each routine in a procedure file",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["PROCLINE()","MISC","Function","PROCLINE()","Returns the source code line number of the current","program or procedure",null,null,null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["PROCNAME()","MISC","Function","PROCNAME()","Returns the name of the current program or procedure","that is being executed",null,null,null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["PROW()","PRINTER","Function","PROW()","Returns the current row on the printer",null,null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["PUBLIC","PROGRAM","Command","PUBLIC <memory variable list>/Clipper",null,null,"Makes memory variables global",null,null,null,null,null,null,"CLIPPER.LIB","Yes","Yes","NANTUCKET"]
["QUIT","PROGRAM","Command","QUIT",null,null,"Closes all files and exits from Clipper",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["READKEY()","SYSTEM","Function","READKEY()",null,null,"FULL-SCREEN EXITING KEYPRESS",null,null,null,null,null,null,null,null,null,"PLUS"]
["READVAR()","MISC","Function","READVAR()","Returns the name of the current GET/MENU variable or a","null string if none if pending",null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["RETRY","PROGRAM","PROGRAMMG","RETRY",null,null,"RETURNS TO CALLING PROGRAM AND REEXECUTES SAME COMMAND",null,null,null,null,null,null,null,null,null,"PLUS"]
["RETURN","PROGRAM","Command","RETURN",null,null,"Ends a program.",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SUSPEND","MISC","Command","SUSPEND",null,null,"HALTS EXECUTION OF .PRG AND PRESENTS DOT PROMPT",null,null,null,null,null,null,null,null,null,"PLUS"]
["TEXT","SCREEN","SCREEN Comma","TEXT...ENDTEXT",null,null,"Displays a block of text date in a command file",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["TYPE()","DATABASE","Function","TYPE()","Returns the data type of a memory variable or database","field",null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["UPDATED()","DATABASE","Function","UPDATED()","Will return .T. if last READ changed any of the data","in the associated GETs",null,null,"READ","IF UPDATED()","REPLACE ID WITH m_ID","ENDIF",null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["@..TO","SCREEN","Command","@ <row,col> [CLEAR] TO <row2,col2> [DOUBLE]",null,null,"Draws a single or double line boxes or lines.  Also CLEARs","an area of the screen",null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["BIOSATTR()","SCREEN","UDF","BIOSATTR()",null,null,"Obtain the current screen attributes from the ROM BIOS",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["CLEAR","SCREEN","Command","CLEAR",null,null,"Erases or clears the CRT screen",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["COL()","SCREEN","Function","COL()","Returns the current column position of the cursor on the","screen",null,null,"? COL()","5",null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["CURSOR","SCREEN","SCREEN UDF","CALL CURSOR WITH <\"on\"/\"off\">",null,null,"Toggle the cursor on and off",null,"@ ....PROMPT \"...\"","CALL CURSOR WITH \"off\"","MENU TO foo","CALL CURSOR WITH \"on\"",null,"TR.LIB",null,null,"RETTIG"]
["MENU","PROGRAM","Command","MENU TO <memvar>",null,null,"Highlights an @..PROMPT and places prompt value in memvar",null,"@  8,10 PROMPT \"ADD\"","@  9,10 PROMPT \"EDIT\"","@ 10,10 PROMPT \"Maintenance\"","MENU TO choice",null,"CLIPPER",null,"Yes","NANTUCKET"]
["RESTORE SCREEN","SCREEN","Command","RESTORE SCREEN [FROM <memvar>]",null,null,"Restores multiple screens saved with SAVE SCREEN TO <memvar>",null,null,null,null,null,null,null,null,null,"CLIP"]
["RESTSCR()","SCREEN","SCREEN UDF","RESTSCR( <filespec> [,<memvar name>])","<expC> false if file not found, otherwise true",null,"Read disk file directly into screen",null,null,null,null,null,null,"TR.LIB",null,null,"RETTIG"]
["ROW()","SCREEN","Function","ROW()","Returns the current row location of the cursor",null,null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SAVESCR()","SCREEN","UDF","SAVESCR( <filespec> [,<memvar name>])","<expL> true if file successfully written, otherwise false",null,"Save current screen to disk file for later use",null,null,null,null,null,null,"TR.LIB",null,null,"RETTIG"]
["SCRATTR()","SCREEN","UDF","SCRATTR()","<expC> uppercase letter value of current SET COLOR",null,"Obtain the current SET COLOR values",null,"scr_value = SCRATTR()","<code that changes the screen>","* Restore original screen","SET COLOR TO &scr_value",null,"TR.LIB",null,null,"RETTIG"]
["SCROLL","SCREEN","UDF","CALL SCROLL WITH <TLrow>,<TLcol>,<BRrow>,<BRcol>,<lines>,U/D",null,null,"Scroll within a specified area on the screen",null,"* Clear all but screen border area","CALL SCROLL WITH 1,1,22,78,0,\"U\"","* Scroll box in middle of screen 3 lines down","CALL SCROLL WITH 10,30,14,50,3,\"d\"",null,"TR.LIB",null,null,"RETTIG"]
["SET COLOR TO","SCREEN","Command","SET COLOR TO [<standard>[,<enhanced>[,<border>]]]",null,null,"Sets screen display attributes",null,null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["TRANSFORM()","CHARACTER","Function","TRANSFORM(<exp>,<picture>)","Returns a character string with the specified picture",null,null,null,"? TRANSFORM( 123456789, \"###,###,###\")","*  Returns 123,456,789",null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["ALLOCATE()","SYSTEM","UDF","ALLOCATE(<bytes>)","<expC> 4-byte hex address of 1st segment.  Null <expC> if","memory cannot be allocated","Provide private memory area to store data outside Clipper",null,"m_buffer = ALLOCATE( 1024 )","IF \"\" = m_buffer    && null means an error","<error message>","RETURN           && abort this routine",null,"TR.LIB",null,null,"RETTIG"]
["BUFFERS()","SYSTEM","UDF","BUFFERS()","<expN> number of buffers on the BUFFERS= line in","Config.sys","Determine setting of BUFFERS in Config.sys",null,"m_buffers = BUFFERS()","IF m_buffers = -1","? \"ERROR --- cannot find Config.sys","IF m_buffers < 10 .OR. m_buffers > 15","? \"ERROR --- set BUFFERS between 10-15 in Config.sys","TR.LIB",null,"Yes","RETTIG"]
["CALL","MISC","SYSTEM","CALL",null,null,"Executes a binary file (module) placed in memory with LOAD",null,null,null,null,null,null,null,"Yes",null,"PLUS"]
["COUNTRY()","SYSTEM","UDF","COUNTRY()","<expN> code on COUNTRY= line in Config.sys","Zero (default) if COUNTRY not specified, -1 if no Config.sys","Determine setting of COUNTRY in Config.sys",null,null,null,null,null,null,"TR.LIB",null,"Y","RETTIG"]
["DATE()","DATE","DATE/SYSTEM","DATE()","Returns the system date in the form mm/dd/yy",null,null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["DEALLOC()","SYSTEM","UDF","DEALLOC( <address>)","<expL> true if successful, otherwise false",null,"Release memory allocated with ALLOCATE()",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["DIR","DISK","Command","DIR [<drive>:] [<path>] [<skeleton>]",null,null,"Displays names of files on the specified disk drive",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["DOSFUNC","SYSTEM","Process","CALL DOSFUNC WITH <registers>, <flags>","<expC> is altered to contain contents of registers after","INT 21H function call","Provide access to INT 21H DOS function calls",null,"CALL DOSFUNC WITH m_regs,m_flags","IF m_flags %2 = 1","? \"Invalid country code\"","ENDIF",null,"TR.LIB",null,"Yes","RETTIG"]
["DOSVERS()","SYSTEM","UDF","DOSVERS()","<expC> DOS version number",null,"Determine which version of PC-DOS or MS-DOS is running",null,"IF VAL( DOSVER() ) < 3.1","? \"This software requires DOS 3.1 or later.\"","QUIT","ENDIF",null,"TR.LIB",null,"Yes","RETTIG"]
["FILEATTR","SYSTEM","Process","CALL FILEATTR WITH <filespec>,<attributes>",null,null,"Turns file attributes on or off",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["FILEREAD()","SYSTEM","UDF","FILEREAD( <filespec> )","<expC> contents of disk text file",null,"Read a text file from disk",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["FILES()","SYSTEM","UDF","FILES()","<expN> number of files on FILES= line in Config.sys",null,"Determine setting of FILES in Config.sys",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["FILESIZE()","SYSTEM","UDF","FILESIZE( <filespec> )","<expN> size of file in bytes",null,"Determine amount of disk space occupied by a file",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["FILEWRITE()","SYSTEM","UDF","FILEWRITE( <filespec>,<text> )","<expC> \"DONE\" is written successfully",null,"Write a text file to disk",null,null,null,null,null,null,null,null,null,"RETTIG"]
["FLOCK()","NETWORK","Command","FLOCK()","Returns a logical .T. if the lock was successful",null,"Attempts to lock a database(.dbt,.ntx in a shared enviroment","so two users cannot access a database at the same time",null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["GETENV()","SYSTEM","Function","GETENV()",null,null,"OPERATING SYSTEM ENVIRONMENT VARIABLES",null,null,null,null,null,null,null,null,null,"PLUS"]
["ISCOLOR()","SYSTEM","Function","ISCOLOR()","Returns a logical .T. if a color display is installed and","a logical .F. for a monochrome display",null,null,null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["LASTDRIVE()","SYSTEM","UDF","LASTDRIVE()","<expC> letter of the drive specified on LASTDRIVE= line","in Config.sys","Determine setting of LASTDRIVE in Config.sys",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["LOAD","SYSTEM","Command","LOAD <binary filename>[.<extension>]",null,null,"Places a binary file into memory where it can be executed","with the CALL command",null,null,null,null,null,null,"Yes","No","PLUS"]
["LOCK()","NETWORK","Function","LOCK()","Returns a logical .T. if the lock is successful",null,"Used to attempt to lock a database(.dbt,.ntx in a shared","environment)so two users cannot access database at same time",null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["MEMORY()","MISC","Function","MEMORY()","Returns the available memory in K bytes.  MEMORY(0) returns","the free pool space for data manipulation",null,null,null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["NETERR()","NETWORK","Function","NETERR()","Will return .F. if a USE,USE..EXCLUSIVE or APPEND BLANK","fails in a network environment","Detects network errors",null,"Command          Cause of Failure","USE             USE...EXCLUSIVE by another process","USE..EXCLUSIVE  USE...EXCLUSIVE by another process","APPEND BLANK    FLOCK() by another process or two","APPEND BLANK attempt at the same time","CLIPPER.LIB",null,null,"NANTUCKET"]
["NETNAME()","NETWORK","Function","NETNAME()","Returns the text of the computer name when Networking","If name never set, a null string is returned.","Works with IBM PC Local Area Network",null,"USE Netname INDEX By_name","SEEK NETNAME()","IF FOUND()","? \"Welcome\" +NETNAME()","ENDIF","CLIPPER.LIB",null,"Yes","NANTUCKET"]
["OFF()","SYSTEM","UDF","OFF( <memvar name> )","<expC> variable's offset address as hexadecimal string",null,"Determine the offset portion of a variable's memory address",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["OFFSET","SYSTEM","Procedure","CALL OFFSET WITH <memvar>,<return memvar>","<expC> offset address of <memvar name> as a hexadecimal","string","Determine the location of a variable in memory",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["OS()","SYSTEM","Function","OS()","Returns the name of the version of DOS under which the","program is running","Determine the name of the operating system",null,"? OS()","DOS 3.10",null,null,null,null,"Yes",null,"PLUS"]
["PEEK...()","SYSTEM","UDF","PEEK...()","<exp> value of data type at requested location",null,"Read data stored at specified memory locations",null,"PEEKBYTE() 1-byte hex    PEEKDBL()  8-byte FP num","PEEKCHAR() 1-byte ascii  PEEKSTR()  Nul-terminated ascii","PEEKINT()  2-byte int","PEEKLONG() 4-byte int",null,"TR.LIB",null,"Yes","RETTIG"]
["POKEBYTE()","SYSTEM","UDF","POKEBYTE()",null,null,"WRITE HEX BYTE TO MEMORY ADDRESS",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["REG()","SYSTEM","UDF","REG( <register name> )","<expC> contents of specified register as hex string",null,"Examine contents of CPU registers",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["RLOCK()","NETWORK","Function","RLOCK()","Returns logical True (.T.) when the lock attempt was","successful.","Attempts to lock current database record.  If the record was","locked by same user, RLOCK() will release the lock",null,null,null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["ROMBIOS","SYSTEM","Procedure","CALL ROMBIOS WITH <interrupt>,<registers>,<flags>",null,null,"Provide access to ROM BIOS function calls",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["SEG()","SYSTEM","UDF","SEG( <memvar name> )","<expC> variable's segment address as hexadecimal string",null,"Determine the segment portion of a variable's memory address",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["SEGMENT","SYSTEM","Procedure","CALL SEGMENT WITH <memvar>,<return memvar>","<expC> segment address of <memvar name> as a hexadecimal","string","Determine locatiob of a variable in memory",null,null,null,null,null,null,null,null,null,"RETTIG"]
["SET EXCLUSIVE","NETWORK","Command","SET EXCLUSIVE ON/off",null,null,"Determines the way in which database and related memo","and index files are opened.  The default setting is ON.","ON  = Non-shared files","OFF = Shared files",null,null,null,"CLIPPER.LIB",null,"Yes","NANTUCKET"]
["TIME()","TIME","Function","TIME()","TIME returns the system time in the format hh:mm:ss",null,null,null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["UNLOCK","NETWORK","Command","UNLOCK [ALL]",null,null,"Release file/record lock, UNLOCK ALL releases ALL locks",null,null,null,null,null,null,"CLIPPER",null,"Yes","NANTUCKET"]
["USE...EXCLUSIVE","DATABASE","Command","USE <filename> [INDEX <index file> EXCLUSIVE[ALIAS <name>]",null,null,"EXCLUSIVE opens file for exclusive(non-shared) use",null,"USE Accounts EXCLUSIVE","IF .NOT. NETERR()","SET INDEX TO Acct_ID","ENDIF",null,"CLIPPER",null,null,"NANTUCKET"]
["DTOSS()","DATE","UDF","DTOSS(<days>)","<expN> number of seconds that equals <days>",null,"Convert days to seconds",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["HTOSS()","TIME","UDF","HTOSS( <hours>)","<expN> number of seconds that equal <hours>",null,"Convert hours to seconds",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["ISTSTIME()","TIME","UDF","ISTSTIME( <time string> )","<expC> time string in the format \"HH:MM:SS\", the same as","the TIME() function","Determine if the time string is valid",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["MAKETIME()","TIME","UDF","MAKETIME(<time string>)","<expC> time string valid in format and contents",null,"Make an invalid time string valid",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["MTOSS()","TIME","UDF","MTOSS( <minutes> )","<expN> number of seconds that equal <minutes>",null,"Convert minutes to seconds",null,"minutes = 285.61","secs    = MTOSS( minutes )",null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["SECONDS()","TIME","Function","SECONDS()","Returns system time as <seconds>.<hundredths>",null,null,null,"start = SECONDS()","DO process","elasped = SECONDS() - Start","? \"Process took \"+ STR(Elasped) + \" seconds\"",null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SSTOD()","TIME","UDF","SSTOD( <seconds> )","<expN> number of days that equal <seconds>",null,"Convert seconds to days",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["SSTOH()","TIME","UDF","SSTOH( <seconds> )","<expN> number of hours that equal <seconds>",null,"Convert seconds to hours",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["SSTOM()","TIME","UDF","SSTOM( <seconds> )","<expN> number of minutes that equal <seconds>",null,"Convert seconds to minutes",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["TIMESTR()","TIME","UDF","TIMESTR( <seconds> )","<expC> time string in the format \"HH:MM:SS\", the same as","returned by the TIME() function","Convert seconds to a time string",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["TSTOH()","TIME","UDF","TSTOH( <time string> )","<expN> number of hours that equal <time string>",null,"Convert time string to hours",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["TSTOM()","TIME","UDF","TSTOM( <time string> )","<expN> number of minutes that equal <time string>",null,"Convert time string to minutes",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["TSTOS()","TIME","UDF","TSTOS( <time string>)","<expN> number of seconds that equal <time string>",null,"Convert time string to seconds",null,null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]
["COPY STRUCTURE","DATABASE","Command","COPY STRUCTURE TO <file> [FIELDS<field list>]",null,null,"Duplicates structure of file in USE to a new database",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["DESCEND()","DATABASE","UDF","DESCEND(<expD>)","Allows indexes of any field type to be created in Descending","order",null,null,"INDEX ON DESCEND(sales_date) TO date_dwn",null,"SEEK DESCEND(find_date)",null,null,"EXTRA.LIB",null,null,null]
["??","SCREEN","Command","?? <exp list>",null,null,"Displays an expression list on the current line of the CRT",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["==","OPERATOR","Command","<exp> == <exp>",null,null,"Compares character types for a perfect match",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["!","OPERATOR","Command","DO WHILE ! .T.",null,null,"The \"!\" may be used in place of the logical .NOT.",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["&&","OPERATOR","Command","&& <text>",null,null,"Allows comments on same line as command",null,null,null,null,null,null,"CLIPPER.LIB",null,null,"NANTUCKET"]
["SOUNDEX()","MISC","UDF","SOUNDEX( <expC> )","<expC> soundex code as a four-character string in the","format \"A999\"","Search for similar sounding names that are spelled","differently",null,null,null,null,null,"TR.LIB",null,"Yes","RETTIG"]